home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Developer Source 9
/
developer source - volume 9.iso
/
dbmsa
/
nov96
/
1ps10.gif
< prev
next >
Graphics Interchange Format
|
1998-02-10
|
97KB
|
409x771
|
4-bit (16 colors)
Labels:
text
|
screenshot
|
menu
|
document
|
font
|
parallel
|
number
OCR:
COMPARISON ORACLET SYBASE SQL CRITERIA VERSION 7.3 SERVER 11 Domains No No Referent:alintegrity violation aptions Restrict, except cascading delete Restrict only Tailt referential messages No No ReferemisE WHERE COusas Lipcatenhle views (with ched option). User-defined dats types Yes BLODS Yes Yes Yes Additional data types Image, video, text, messaging, spatial Binary, image, money, bit, text, Table structures data types varbinary Hesp, clustered Index Structures Heap, clustered B.tree, bitmap, hash B-tree Tuning factit'es Table and index allocation Index pre fetch, I/O buffer cache, block size, table partitioning Triggers Row based, set based Set-based Timing Before, after Nesting After Yes Yes Stored procedures Language PL/SQL Transact SOL Nesting TOS Cursors Yes Yes Extertal cats RPC Events Yes Time-based events Leching level Table, Zow Table, poge ANSI SQL compiance Entry-Level SQL-92 Entry-Level SOL-92 Forward Forward Cucur joins ANSI syntax No ODBC DELIB, CTLIA, ODBC Database Administration Tools Oracle Enterprise Manager, Sybase SQL Manager, SQL Monitor Performance Pack SNMP support Security C2 (Trusted Oracle) Yes Partial backup and recovery Configurable C2 Configurable Internes support Oracle Web Server web.sql Connectivity, Middleware, and Distribution Gateways to other DEMSs Any MVS data source through Adabas, AS/400, DB2, FDMS, IMS, EDA/SOL (Adobes, IDMS, IMS, SQL'DS, Informix, Ingres, ISAM, Microsoft VSAMI, any APPC data source, AS/400, : SQL Server, Oracle, Rdb, RMS, ORDA, DB2, Turbelmage, Sybest, Rdb, cequential files, SQL/DS, Sybase RMS, Informix, CA-Ingres, SQL Server, SQL Server, Teradata, VSAM Teradata Distributed databases Part of base product OmniConnect 2PC protocol Yes Yes Heterogeneous Through gateways Through DirectConnect Optimization Yes Ye Yer Recording Replication lag triggers Log buffer Hot standby Yes Ye Peer-to-peer To other DOMSs Through gateways Through DirectConnect Cascading Yes Yo Additional Restrictions Name lengths Columns 30 254 30 250 Column size 2GB 1962 Tables 2 bilion Table size Table wwidth storage dependent Platforms [operating system) By columin storage dependent Most Unix systems, Windows NT, VAX Most Unix systems, Windows NT, VMS. Windows 95, 05/2, Macintosh VAX VMS, Windows 95, OS/2, Macintosh
